﻿CREATE PROCEDURE [Messenger].[SP_MessaggiDaRicevere_CL]
	@Receiver nvarchar(50)
AS
	SELECT MessaggioID, Sender, Receiver, TestoMessaggio, IsDelivered, IsRead, TimeStamp_Insert
	FROM Messenger.Messaggio
	WHERE Receiver = @Receiver AND IsDelivered = 0
RETURN 0